﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlServerCe;
using EzDesk.DesktopClient.Model;
using System.Data.SQLite;
using DbLinq;
using DbLinq.Sqlite;
using System.Data.SQLite;


namespace SqlCompactTest
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = @"Data Source=C:\Documents and Settings\Tomas.huang\My Documents\EzDesk\EzDeskDev\EZDesk-Dev\Core\Clients\DesktopClient\EzDesk.DesktopClient\bin\Debug\user\data\database\EzDesktopClientDb.db";


            EzDesktopClientDataContext client = new EzDesktopClientDataContext(new SQLiteConnection(connectionString));
                

            foreach (var item in client.Feed)
            {
                item.UpdateOn = DateTime.Now;
                Console.WriteLine(item.AppName);
            }
            client.SubmitChanges();
            Console.ReadKey();
        }

    }
}
